
/*
'===============================================================================
'  Generated From - DAAB_DAL_NET2_Inherited.vbgen
'  It is based on the DAAB from the November 2005 Enterprise Library
'  
'  This object inherits properties, members and methods from the base class _VenueRequirement_DAL.
' 
'  Use this class file for writing custom DAL methods. 
'  
'  Version: 1.0
'  Date:	30/01/06
'  Summary: Defaul constructor.
'===============================================================================
*/
using System;
using System.Data;
using System.Data.Common;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;


namespace PlacementManager.DAL
{
    public class VenueRequirement_DAL : _VenueRequirement_DAL
    {
        //Constructor
        public VenueRequirement_DAL()
        {

        }

        /// <summary>
        /// Purpose: Select method for a foreign key. This method will Select one or more rows from the database, based on the Foreign Key 'VenueId'.
        /// </summary>
        /// <returns></returns>
        public DataSet SelectAllWVenueIdDivisionId()
        {
            // Create the Database object, using the default database service. The
            // default database service is determined through configuration.
            Database db = DatabaseFactory.CreateDatabase("PlacementManager");
            string sqlCommand = "pr_VenueRequirement_DAL_SelectAllWVenueIdDivisionId";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
            db.AddInParameter(dbCommand, "VenueId", DbType.Int32, _VenueId);
            db.AddInParameter(dbCommand, "DivisionId", DbType.Int32, _DivisionId);
            db.AddOutParameter(dbCommand, "ErrorCode", DbType.Int32, 4);
            DataSet dsToReturn = null;
            dsToReturn = db.ExecuteDataSet(dbCommand);
            return dsToReturn;
        }
	}
}
